create external table jms_dm.dm_cusc_customer_abnormal_flow_summary_dt
(
    customer_id           string comment '客户id',
    customer_code         string comment '客户编码',
    customer_name         string comment '客户名称',
    customer_network_code string comment '客户所属网点code',
    customer_network_name string comment '客户所属网点name',
    customer_fran_code    string comment '客户所属加盟商code',
    customer_fran_name    string comment '客户所属加盟商name',
    customer_agent_code   string comment '客户所属代理区code',
    customer_agent_name   string comment '客户所属代理区name',
    order_source_code     string comment '订单来源code',
    order_source_name     string comment '订单来源名称 ',
    end_virt_code         string comment '目的网点(代理区)虚拟代理区',
    end_virt_name         string comment '目的网点(代理区)虚拟代理区',
    no_taketimely_num     int comment '未及时揽收量',
    no_collect_num        int comment '不准点交件票量',
    false_taking_num      int comment '虚假揽收量',
    no_outtimely_num      int comment '出港不及时量',
    no_signtimely_num     int comment '未及时签收量',
    complaint_num         int comment '客诉量',
    sign_difftime_num     int comment '超24小时揽签量',
    problem_num           int comment '问题件量',
    lose_problem_num      int comment '问题件遗失量',
    worn_problem_num      int comment '问题件破损量',
    pollute_problem_num   int comment '问题件被污染量',
    other_problem_num     int comment '问题件其他量',
    abn_total             int comment '异常总量',
    date_time             string comment '日期'
) comment '智兔app-客户异动流向汇总'
    partitioned by (dt string comment '分区日期')
    stored as parquet
    location '/dw/hive/jms_dm.db/external/dm_cusc_customer_abnormal_flow_summary_dt'



